Direct Store Delivery Application

The Direct Store Delivery, or DSD, application allows distributors to manage direct sales from their mobile warehouses, typically trucks, to their customers. Operators of the mobile warehouses, or truck drivers, can use the DSD application to access their orders on a daily basis. The requirements necessary to install the application and the process of downloading and deploying the application are detailed in the Mobile and Direct Store Delivery Requirements and Installing Mobile and Direct Store Delivery pages.

More tab

The More tab contains the route options and DSD application settings.

Field/Flag

Description

Login

Click to display the login screen and enter the appropriate username and password.

  • Note: As indicated previously, you may select 'Remember Credentials' to save the ID and password to the Device. Once the username and password have been entered, users may click the word "Login" at the top right hand side of the form to complete the process.

Start Route

Start route is only displayed after users have logged into the DSD application. Once clicked, the application will load all inventory, locations and orders. Once the daily delivers/orders have been loaded, users may process the orders using the options available on the DSD tabs discussed further down on this page.

End Route

Click to complete the route and sync all orders and inventory to the main Deacom application. This should be done at the facility while connected to the appropriate wireless network. Clicking this button will force a system prompt to appear. The prompt will display either "Yes" to continue and end the route or "Cancel" to return to the DSD application without ending the route.

  • If errors occur the user will be presented with a prompt (beginning in version 17.01.071) with detailed information on the errors together with the order numbers that contains the errors.

Map

The map tab displays the locations of all loaded orders for the selected route. The blue dot on the map represents your current location. Red pins will appear at the address of the ship-to companies for all orders on the selected route. Drivers may select a red pin to view the order number, ship-to company, and order priority. Drivers may drill into the sales orders from here as well.

Sync Orders

Allows users to sync all orders or filter for a specific set of orders to sync. Note that saved orders are automatically synced when ending the route. The following fields are available to this form:

  • Date Based On - Allows users to filter their sales orders based on the different sales order dates. The default value for this field is the due to ship date.
  • DSD Sync Status - Determines what orders will be synced. Options are "Shipped" and "Not Shipped". The default value for this field is set via the "DSD Sync Status" field in Sales Options.
  • Route - Determines the ship via(s) that will be considered when syncing and displaying orders. Options are All and Current. "Current" filters down by current ship via while "All" does all ship vias.

Notes:

  • Related to the sync orders functionality, beginning in version 17.02.010, sales order date calcs are processed and synced to sales orders in DSD. If the DSD is not online, the system will track if there are any sales dates and/or sales date calcs so that these may be synced when the device is back online.
  • Sales order calculations are enabled in DSD beginning in version 17.02.010. The calcs will fire, and store against the orders the same as in main application. Calculations will also add parts to orders when saved the same as in the main application. This occurs when the device is online. If the device is not online, the system will track what calculations need to be fired, and fire/sync them when the device is back online.

Start Route Data Syncing Logic:

The DSD application will sync Bill-Tos, Ship-Tos, Orders, and Templates according to the following conditions and logic:

  • The system will first determine if the ship via on the route requires approval (tr_approvalreq)
    • If true sync the following records to the device
      • Ship-to's where useable in DSD (sh_routeacct) is true
      • Bill-to's where useable in DSD (bi_routeacct) is true (all useable related Bill-Tos will sync)
      • Orders with a ship via matching the route(to_trid), due to ship today, and both the bill-to and ship-to on the order are useable in DSD(sh/bi_routeacct = true)
      • Templates with a ship via matching the route(to_trid), where both the bill-to and ship-to on the order is useable in DSD, and the ship-to on the order had a dmtrukauth record for the ship via.
    • If false sync the following records to the device
      • Orders with a ship via matching the route(to_trid), due to ship today, and both the bill-to and ship-to on the order are useable in DSD(sh/bi_routeacct = true)
      • Ship-to's where useable in DSD (sh_routeacct) is true and the ship via on the ship-to(sh_trid) matches the ship via on the route and the ship-to was on a synced order, regardless of the ship via on the ship-to.
      • Bill-to's where useable in DSD (sh_routeacct) is true and the ship via on the bill-to(bi_trid) matches the ship via on the route and the bill-to was on a synced order, regardless of the ship via on the bill-to and the bill-to is related to a ship-to that was synced.
      • No templates - This only happens with authorization required.

Reprint End of Route

Option to reprint the end of route report. The end of route report includes a list of all delivered orders with details that include the order #, customer name, order total, and paid total. Additional information including a template for the report is available via Print Outs > Maintenance > DSD Layouts.

Finalize Route

The finalize route button works in connection with the route results button. In the event that orders cannot be fully saved or shipped during the day (e.g. due to an insufficient inventory situation or message), the DSD application will still allow the end route process to continue. Any issues that occurred while saving or shipping orders will be displayed on the route results form. Clicking on the finalize route button will simply warn the user if there are any system prompts/errors, log the user out, and clear any order data. This allows orders that encountered issues to still be saved in the system so that they can be shipped in the main Deacom application after inventory and related issues have been resolved.

Route Options

Click to display the "Route Options" form where the appropriate ship via method, location type, location, and cash account are selected. Once the appropriate selections have been made, click the word "Done" at the top right hand side of the form. Note that if another location type is selected or if the location type is cleared, the location field will be cleared as well. Note that the cash account is editable even after a route has been started.

  • The "Start Route" button is available to this screen beginning in version 16.07.057 in order to save time and inputs for the user when starting a route in the DSD application.

Settings

The settings button option allows users to specify or change the Deacom WEB URL, display the version of the DSD application that is currently installed, and provides the option to define the printer type for the DSD device. The available printer options are Zebra (default) and Bixolon. The majority of the settings on this form will use the default values and should not be changed. Once any necessary changes have been made, click the word "Done" at the top right hand side of the form.

Route Results

Click to display a list of orders that may have issues when attempting to save/ship or any backorders that were created during the route. Users have the option to click the "Order Info" button on the top right hand side of the form to display additional information.

Order History

Displays DSD order history for the past 20 days. Order history that is over 20 days old will be removed from the device to save device storage space.

Logout

The "Logout" option is displayed after users have logged into the DSD application and before clicking the "Start Route" option. Once a route has been started, clicking the "End Route" option automatically logs the user out of the DSD application.

Orders tab

The Orders tab lists sales orders, and if applicable, Sales Order Templates.

  • Sales orders are listed based on the priority specified on the Misc 1 tab of the Sales Order header.
  • Sales Order Templates are listed based on the sequence (ta_seq) defined on the Authorized Ship-To Companies tab of the Ship Via Method matching the DSD route's Ship Via Method record, then by the priority on the Misc 1 tab, and finally the order number.

The form is also used to perform all shipping and delivery transactions. As drivers reach their destinations, they will select the appropriate order, click the "Ship Order" button, and perform the delivery. Note that shipping the order in the DSD application marks the order as shipped but that the order is not shipped in the main application until the route has been ended via the Options form on the More tab.

Note on order filters: The 'Not Shipped Due Today' option will filter on orders not shipped, and due to ship today. The 'Not Shipped All' filter will show all non-shipped orders regardless of due date.

Orders tab buttons/fields

Button

Description

+

Opens the Sales Order Entry form. An existing sales order must first be selected prior to clicking this button.

Templates

Combobox displaying the sales order templates with a Ship Via Method matching the Ship Via Method specified in the DSD Route.

  • This field is enabled when the "Sync Templates in DSD" field is checked on the DSD tab in Sales > Options.
  • Sales Order Templates are listed based on the sequence (ta_seq) defined on the Authorized Ship-To Companies tab of the Ship Via Method matching the DSD route's Ship Via Method record, then by the priority on the Misc 1 tab, and finally the order number.
  • Beginning in version 16.07.057, when the user clicks "Apply" after selecting a template to use on a DSD route, the template will be removed from the templates screen until the user ends the route. This helps ensure users will not select the same order template for that route more than once.

Sales Order Entry form

Field/Flag

Description

Orders

The orders button is located at the top left hand side of the sales order entry form and is used to return to the list of sales orders for the selected route.

Order Number

The Deacom sales order number. When the device is connected, saving the order will cause the system to assign the appropriate sequential order number. If an order is saved while the device is offline (for example - in Airplane mode) the Order Number field will read '(Current Date and Time) - On Route'. Example: (03/19/2014 11:04 AM) - On Route. Once the device is back online, resaving the order will cause the order to be synced and correct order number will be assigned.

Bill-to

Use the search icon to select the appropriate bill-to record.

Ship-to

If the selected bill-to customer contains a default ship-to record, this ship-to will be displayed. Users may select another ship-to record if necessary.

Ship-to PO

Read only. Displays the ship-to companies purchase order number, if present.

Sales User 3

This field represents the user-defined search box data for this sales order. The default value for this field defaults from the selected Ship to company, but can be changed. Additional information regarding the sales user fields is available via Sales > Maintenance > Sales User 1-5.

Terms

The payment terms for this order. Defaults from the Ship to company, but can be changed.

Facility

The facility that will ship this order. If users are restricted to a specific facility, this field will be read only.

Ship Via

The ship via method for this sales order. Defaults from the Ship to company, but can be changed by users who have permission via the "DSD -- Change Ship Via" security setting. Note that the Customers pre-filter in the main Deacom application contains a "Ship Via" pre-filter to assist with filtering customer based on their default ship via assignments.

Due to Ship

The date the order is set to ship. When new orders are entered, today's date will be used. This field is display only, unless the user has the security setting "DSD--Change Due Date" set to yes which allows this field to be modified.

Order Contact

Denotes the contact person linked to the sales order. If the user has not selected a Customer for the order, selecting this field will display all Order Contacts in the system. If a Customer has been selected, the order contacts for that Customer will be displayed.

Header Notes

Notes that apply to the entire sales order. Normally printed on all sales documents.

Order Priority

The default value will be provided by the priority specified on the order defaults tab of the ship-to company. Before selecting a Ship-To company, it will display 0.

Total Order

Display only. The sum of the extensions on the sales order lines.

Ship Order

Displays the "Lines To Ship" form where users may confirm shipment quantities, add order lines and/or reserve specific lots. Additional information is available within the "Shipping Orders" section further down on this page.

  • The "Expiration Date" field is available on the Reserve form/screen in the DSD application to support returns of items that require an expiration date. Added in version 17.01.071.

Actions

Click to add items to the Sales Order, view customer detail, save the new order, and have customers sign for the order. The selections available vie the actions menu include:

  • Save - Click to save the order. As indicated previously in this document, sales orders in the DSD application may be saved without adding lines so that lines can be added later via scanning. Orders however cannot be shipped without lines.
  • Lines - Click to display the "Order Lines" form. This form displays all the order lines for the selected order. Additional lines may be added by clicking the "+" button on the top right hand side of the form.
  • Customer Detail - Displays additional detail for the customer on the order. Users may call or email customers directly from this form using the green icons to the far right of the Phone and Email fields.
  • Capture Picture - If clicked, will display the capture picture form. Useful in situations where drivers need secure pictures of any damaged items. If pictures are captured, they will be available for display in the main application via the "View Docs"* button on the sales order. Note that multiple images can be captured for one order.
  • Cancel Order - If the user selects 'Cancel Order' from the Actions button, the order type is changed to canceled and the Order is removed from the list on the "Orders" tab. Clicking this button will prompt the user: ""Would you like to cancel this order?" Yes/No. If Yes is selected, the order will be cancelled. If No is selected, the system will close the prompt and go back to the order. Note that selecting the "Back" button will return users to the "Sales Order Entry" form.
  • Promotions - Click to add any available/applicable sales promotions to the sales order. Promotions are added from this form by moving them to the right hand side of the form and clicking the "Continue" button. Promotions are created and maintained within the main Deacom application via Sales > Maintenance > Promotions and Discounts. Note that promotions may be automatically added to sales orders within the main application and in the DSD application by using the "Automatically add to orders" check box on the promotional code itself. In addition, when printing invoices from the DSD application, promotions will be printed/displayed at the bottom of the list.
    • Note: Within the DSD application, promotional codes are recalculated when the order is shipped to ensure the promotional code(s) is calculated based on the shipped quantity.

Note:Bill-To and/or Ship-To popup notes will be displayed in the DSD application.

Edit Sales Order Line form

Field/Flag

Description

Line Number

Displays the line number that is being added or edited.

Part Number

Used to select a part from a list of active, DSD salable part numbers. Specifically, the searchbox is filtered to only show items that are on the restricted selling list at the bill-to, ship-to, or facility level. This applies to category, sub-category, Item Search 1-5, and part-exclusion restricted selling. Additional information on part exclusions and restricted selling is available in the Part Exclusions section via Inventory > Item Master.

Quantity

Enter the appropriate order units that will be ordered.

On Hand Quantity

Displays the on hand inventory available for this Part based and is limited to the to inventory in the location the DSD device is synced to.

  • For a quantity to be displayed in this field, the "On Hand Calculation" field in Sales > Options > Order Entry tab must be set to "On Hand - Open Orders".
  • Displays with a mask of 999,999,999.99

Shipped Quantity

Indicates the quantity of this item that has already been shipped on the selected order.

Note: This field is editable to allow for short-shipping.

Sales Unit

The units in which the part will be sold. The sales unit should be selected in consideration of how customers will order items.

Unit Price

The pricing unit of the product. Pricing is based on a hierarchy of pricing options. The single most specific pricing method is automatically chosen to provide the default unit price, which can be overridden manually unless prevented by user security.

Notes:

  • Price variance limits, options and variance types may be set in Sales Options.
  • Deal pricing is available for use in the DSD application. Deal pricing is part of the Deacom pricing hierarchy and is maintained via Sales > Maintenance > Deal Pricing.

Extension

Total amount for this sales order line.

Return Reason

Available only when creating or modifying credit memos (e.g. sales orders containing a negative quantity) Note that return reasons contain a "Move Inventory To" field which specifics whether returned items will be moved to regular inventory or quarantine once the credit memo is shipped. Additional information is available via Sales > Maintenance > Return Reasons.

  • Note: A return reason must be specified anytime a negative quantity is indicated on the sales order line, unless the user has the security setting "DSD - Enter negative line without return reason" set to yes.

Line Notes

Notes that apply only to this sales order line. Normally printed on all sales documents.

Do Note Post Inventory

Used when creating a credit memo. Indicates this sales order is a credit only and the customer is not returning physical product. Inventory costs will not be posted. Leave the box unchecked to return material back to inventory (e.g. RMA). The security setting "Sales orders -- do not post inventory" determines whether the do not post inventory flag is enabled or disabled when creating a new sales order.

Actions

The actions button on the edit sales order line form contains two options: one to post the changes and save the line item and two, to delete the line item.

  • Once a user has saved the line item, they will be prompted to save the entire order in order to complete the save. Note that once the line item has been posted, users will need to click the "Order Lines" button located on the top left hand side of the form in order to go back and add additional lines to the order.
  • Later versions of the DSD application recognize a left swipe event on the order lines form that shows the delete button, allowing the user to delete lines items on the order.

Lines to Ship form

Opened via the "Ship Order" button on the bottom of the Sales Order Entry form.

Sign For Order

Displays the order signature form used to capture customer signatures. If a signature is captured, it will be available for display in the main application via the "View Docs" button on the sales order. If a signature is captured on an order it will appear at the bottom of the invoice when the invoice is printed.

Select Lots button

The "Select Lots" button is available on the Lines to Ship form. Note that when using this button and drilling in a lot a form is displayed which indicates the lot quantity. This form allows users to change the unit price and add a Return Reason, if desired. If the unit price is changed and the form is saved, the order is re-synced and the system updates all of the totals.

Note: The Select Lots button is disabled when the Required quantity is negative.

Payments form

Opened via the "Order Payment" button. Note that the Order Payment button will only be available if a Cash Account is selected via "Route Options".

Field/Flag

Description

Amount Paid

Represents the amount received by the driver/amount paid by the customer.

Reference

Optional character text box for adding notes or details about a particular sales or transaction. The reference field is available to print on the DSD receipt.

Payment Type

Displays the default payment type as set in Accounting > Maintenance > Payment Types. Uses may select from active payments types via the drop down list.

Amount Due

Order Total Remaining

Validation ID

Option to require a validation ID during payment. Any payment types marked to use validation will require a validation ID to be entered, usually a driver's license number. Additional information on payment types is available via Accounting > Maintenance > Payment Types.

Split Payment

Option to split the payment between any of the active payment types in the Deacom system. If this option is selected, when the "Save" button is clicked, the "Enter Split Payment" form is displayed. Additional information is available in the "Splitting Payments" section below.

Notes:

  • To exit this form without entering a payment, click the "Close" button in the top left. To apply a payment to the order, click "Save" in the top right.
  • If there is no cash account selected in the route options, then the Payment Type's POS account will be using when payments are applied.

Enter Split Payment form

Opened via the "Split Payment" flag on the Enter Payment form.

Field/Flag

Description

Payment Type

Contains all active Payment Types as configured in the main application.

Reference

 

Amount

 

Print Invoice form

Opened via the "Print Invoice" button.

Notes:

  • The DSD application contains the ability to zoom in, by pinching and expanding, invoices and receipts.
  • Multiple invoice receipt layouts may be created for use in the DSD application. Additional information is available via Print Outs > Maintenance > DSD Layouts.
  • When viewing the invoice form. prior to printing the invoice, the signature for the order (if there is one) will be presented in a new view.

Payments tab

Click to display the "Outstanding Orders" form. This option is useful when customers present the driver with one check to cover that will pay multiple orders. This option is different than the process discussed above which is used for one time payments which generally occur when drivers make a delivery, invoice the order and accept payment simultaneously. The process for using the "Payments" option is detailed below.

Inventory tab

Click to display the Inventory Reporting form. This form allows delivery personnel to check on hand quantities of order items. Note that this form may be used to show all inventory regardless of the location type and location specified in route options.

Field

Description

Report Type

Set to "On Hand" and cannot be changed.

View

Drop down available to select the different inventory views or segments. The different inventory segments include:

  • Reserved
  • Inter-Company Transit
  • Quarantine (When selected, display inventory on the on hand and lots reports that is currently in quarantine.)
  • All

Part Number

Option to select a specific part number to filter results.

Part Starts With

Option to search the active item list for part numbers that start with the same character.

View Button

Click to display the selected inventory report.

Notes:

  • The catch weight (fi_catchweight) field may be displayed on the inventory on hand and inventory detail report layouts.
  • The on hand report in the DSD application groups by part numbers and sums the quantities and catch weights.
  • If users need to see an inventory report without the part numbers grouped, the "Lots" report in the DSD application may be used.
  • Once the results of the pre-filter have been displayed, to select or view the record/entry, press and hold for 3 seconds then release.
  • Inventory allocated to the DSD application is contained in it's own Inventory Segment with in Deacom.